Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
REEFTintegrationLog_test
/
REEFTintegrationLog
/
include
:
web-connect-mssql.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php //====================================================================================== // Function: Connect to MSSQL DB //====================================================================================== // $serverName = "JJ-HOME\MSSQL_1"; // $connectionInfo = array( "Database"=>"reeft_db", "UID"=>"sa", "PWD"=>"costello" ); // $conn = sqlsrv_connect( $serverName, $connectionInfo); // if( $conn === false ) { // die( print_r( sqlsrv_errors(), true)); // } $server = "JJ-HOME\MSSQL_1"; $user = "sa"; $pwd = "costello"; $database = "reeft_db"; try { $conn = new PDO( "sqlsrv:Server=$server;Database=$database", $user, $pwd ); } catch ( Exception $e ) { die( print_r( $e->getMessage() ) ); } ?>